Index Spool
Short Description
Index spool scans the input rows and builds a nonclustered index on the rows in a hidden object.
Detailed Description​
Index spool scans the input rows and builds a non-clustered index on the rows in a hidden object. The object only lives for the time of the query and allows use of the SEEK capabilities of a non-clustered index to output selected rows only.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.